Creating KPI Cards 14

STEP 1: Create the Warned Pilots % KPI. Follow along with the GIF to create.

STEP 2: Create the YOY% Warned Pilot Inc/Dec. Follow along with the GIF to create.

STEP 3: Create the Damage Inidcated %. Follow along with the GIF to create.

STEP 4: Create the YOY% Damage Inc/Dec. Follow along with the GIF for this one.

STEP 5: Create Total Repair Cost. Copy and Paste the Indicated Damage %. 

STEP 6: Create YOY% Repair Cost Inc/Dec. Copy and Paste the YOY% Damage Inc/Dec because it is formatted the same way.


STEP 1: Create the Warned Pilots % KPI. Follow along with the GIF to create.


 


STEP 2: Create the YOY% Warned Pilot Inc/Dec. Follow along with the GIF to create. It will take a bit of time for the color to come in.


 


STEP 3: Create the Damage Inidcated %. Follow along with the GIF to create.




STEP 4: Create the YOY% Damage Inc/Dec. Follow along with the GIF for this one.





STEP 5: Create Total Repair Cost. Copy and Paste the Indicated Damage %. Follow GIF to complete.







STEP 6: Create YOY% Repair Cost Inc/Dec. Copy and Paste the YOY% Damage Inc/Dec because it is formatted the same way.



Creating KPI Cards 14

STEP 1: Create the Warned Pilots % KPI. Follow along with the GIF to create.

STEP 2: Create the YOY% Warned Pilot Inc/Dec. Follow along with the GIF to create.

STEP 3: Create the Damage Inidcated %. Follow along with the GIF to create.

STEP 4: Create the YOY% Damage Inc/Dec. Follow along with the GIF for this one.

STEP 5: Create Total Repair Cost. Copy and Paste the Indicated Damage %. 

STEP 6: Create YOY% Repair Cost Inc/Dec. Copy and Paste the YOY% Damage Inc/Dec because it is formatted the same way.


STEP 1: Create the Warned Pilots % KPI. Follow along with the GIF to create.


 


STEP 2: Create the YOY% Warned Pilot Inc/Dec. Follow along with the GIF to create. It will take a bit of time for the color to come in.


 


STEP 3: Create the Damage Inidcated %. Follow along with the GIF to create.




STEP 4: Create the YOY% Damage Inc/Dec. Follow along with the GIF for this one.





STEP 5: Create Total Repair Cost. Copy and Paste the Indicated Damage %. Follow GIF to complete.







STEP 6: Create YOY% Repair Cost Inc/Dec. Copy and Paste the YOY% Damage Inc/Dec because it is formatted the same way.